Column Access Modifier Registry entry

Modify the default Column Access values based on data found in the current record.

Description

The Column Access Modifier Registry entry is used to modify the default Column Access values based on data found in the current record.

Usage

This Registry entry can be assigned to users and groups:

Key User User Group Group Group Group
Key 1 User User Group Group Group Group
Key 2 user user group group Default Default
Key 3 Table Table Table Table Table Table
Key 4 table Default table Default table Default
Key 5 Column Access Modifier
Key 6 column
Key 7 value
Value settings

where:

column

is the back-end name for a field to be consulted to look for a matching value.

value

is a case insensitive match (i.e. patterns / wildcards are not allowed, unlike with the Security | Update Registry entry). The value is checked against the complete contents of column. If column is a table of values, each entry in the table is tested. If one matches, the Registry entry applies. Values of NULL and NOT NULL may be used to represent empty and non-empty values respectively.

settings

is a semicolon separated list of assignments to columns that is applied if there is a match of the data in column with the value query.

The format of settings is:

column=[+/-]perm:[+/-]perm:...;column=[+/-]perm:...

where:

column is the name of the column to be modified.

perm

is the permission to be adjusted.

  • A leading plus sign is used to add a permission.
  • A leading minus sign removes a permission.
  • If no sign is supplied, the current permissions are replaced (as for the Security Update entry).

The list of possible values for perm is:

dvDisplay see column while viewing a record.
dvEdit see column while modifying a record.
dvInsert see column while inserting a record.
dvQuery see column while searching for a record.
duEdit change column while modifying a record.
duInsert change column while inserting a record.
duQuery change column while searching for a record.
duReplace use column in a global replace command.

Examples